/**
 * 
 */
package mdb.com.vn.model;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;


/**
 * @author tu.dod
 *
 */
@Entity
@Table(name="IFTB_SCRATCH_CARD")
@NamedQueries({
	@NamedQuery(name = "ScratchCard.findByRef", query = "SELECT c FROM ScratchCard c WHERE c.transRef = :transRef"),
	@NamedQuery(name = "ScratchCard.findByRef1", query = "SELECT c FROM ScratchCard c WHERE c.transRef1 = :transRef1"),
	@NamedQuery(name = "ScratchCard.findByStatus", query = "SELECT c FROM ScratchCard c WHERE c.status = :status"),
	@NamedQuery(name = "ScratchCard.countByDeno", query = "SELECT sum(c.quantity) FROM ScratchCard c WHERE c.scDenomination = :scDenomination")
})
public class ScratchCard extends AuditPojo implements Serializable{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO, generator = "GSEQ_SC")
	@SequenceGenerator(name = "GSEQ_SC", sequenceName = "SEQ_SC")
	private long id;

	@Column(name="SC_DENOMINATION")
	private double scDenomination;

	@Column(name="SC_DESRIPTION")
	private String scDesription;

	@Column(name="STATUS")
	private int status;

	@Column(name="TRANS_REF")
	private String transRef;
	
	@Column(name="TRANS_REF1")
	private String transRef1;
	
	@Column(name="CUSTOMER_REF")
	private String customerRef;
	
	@Column(name="QUANTITY")
	private int quantity;
	

	public long getId() {
		return id;
	}

	public void setId(long id) {
		this.id = id;
	}

	public double getScDenomination() {
		return scDenomination;
	}

	public void setScDenomination(double scDenomination) {
		this.scDenomination = scDenomination;
	}

	public String getScDesription() {
		return scDesription;
	}

	public void setScDesription(String scDesription) {
		this.scDesription = scDesription;
	}

	public int getStatus() {
		return status;
	}

	public void setStatus(int status) {
		this.status = status;
	}

	public String getTransRef() {
		return transRef;
	}

	public void setTransRef(String transRef) {
		this.transRef = transRef;
	}

	public String getCustomerRef() {
		return customerRef;
	}

	public void setCustomerRef(String customerRef) {
		this.customerRef = customerRef;
	}

	public int getQuantity() {
		return quantity;
	}

	public void setQuantity(int quantity) {
		this.quantity = quantity;
	}

	public String getTransRef1() {
		return transRef1;
	}

	public void setTransRef1(String transRef1) {
		this.transRef1 = transRef1;
	}

	

}
